Open topic with navigation

iLoADER

 HOME

Creating User Variables within iLoader

Variable name assignments can be used within iLoader Data Transformation scripts in order to avoid repeating blocks of code.

Using Variables within iLoader

It is possible to use variable name assignments in the iLoader Data Transformation scripts to repeat complex tasks without having to repeatedly type or copy/paste/modify blocks of code.

Consider this iLoader script fragment:

EXPRESSION [database].[table] , lifeA Policy Age , { daysto( [lifeA Incept Date], _TODAY) }

DOMAIN [database].[table] , lifeA expired , {select # from table where [lifeA policy Age] > 365; }

This creates two columns:

  • The age of the insurance policy lifeA.
  • A domain containing all lifeA policies over 1 year old.

If a database contained several field pairs for a lot of policies (lifeA, lifeB, etc.) then the following file should be created in the scripts directory:

‘ start of file CreateLifeFields.txt

EXPRESSION [database].[table] , %fld% Policy Age , { daysto( [%fld% Incept Date], _TODAY) }

DOMAIN [database].[table] , %fld% expired , {select # from table where [%fld% policy Age] > 365; }

’ end of file

This can then be used in the Data Transformation script file as follows:

Set fld = LifeA

PROCESS CreateLifeFields.txt

Set fld = LifeB

PROCESS CreateLifeFields.txt
  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice